Q • Question 1 4 out of 4 points Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation of the DRIVE variable by using =AVERAGE(A2:A36) and =STDEV(A2:A36). (Round your answers to 5 decimal places) The mean of the DRIVE variable is [x]. The standard deviation of the DRIVE variable is [y]. Assuming that this variable is normally distributed, what proportion of the data would you predict to be less than 40 minutes? This would be based on the calculated probability. To approximate this probability with Excel, find a free cell on the spreadsheet and use the formula =NORM.DIST(40,mean,stdev,TRUE). For the "mean" and "stdev" in the formula, you don't want to type those words, you want to actually enter the cell numbers in which you just found the average and standard deviation of your DRIVE variable. (Round your answer to 3 decimal places) • Question 3 2 out of 2 points Now, determine the actual proportion of data points in the dataset that fall within this range (less than 40 minutes). To find the actual proportion, sort the DRIVE variable, and count how many of the data points are less than 40. Then, divide that number by the total of 35 data points. (Round your answer to 3 decimal places) Answer: The actual proportion of values less than 40 minutes is ___________. • Question 4 2 out of 2 points How does your predicted probability from question 2 compare to the actual probability calculated in question 3? In other words, if these values are different, why do you think they're different, etc?

View Related Questions